SQL data in one field separated by coma

Question

Aryan Kumar · Answer

Sure, you can use the GROUP_CONCAT() function to return data in one field separated by commas in SQL. The syntax is as follows:
SQL
SELECT GROUP_CONCAT(column_name, ',') AS column_name
FROM table_name;
For example, if you have a table called products with the columns
name and price, you could use the following query to return all product names in a single field separated by commas:
SQL
SELECT GROUP_CONCAT(name, ',') AS names
FROM products;
This would return a single field with a comma-separated list of all product names.
Here is an example of how to use the GROUP_CONCAT() function in MySQL:
SQL
CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300);
SELECT GROUP_CONCAT(name, ',') AS names
FROM products;
This will return the following result:
names
Product 1,Product 2,Product 3
As you can see, the GROUP_CONCAT() function has returned all product names in a single field, separated by commas.
Here are some additional things to keep in mind when using the GROUP_CONCAT() function:
The GROUP_CONCAT() function only works with string columns.You can use the SEPARATOR keyword to specify a different separator character than a comma.You can use the DISTINCT keyword to remove duplicate values from the results.

forum

SQL data in one field separated by coma

Revati S Misra

Can you answer this question?

1 Answers

Liked By